/*
*
* OrderSettlementExample.java
* @author 18304
* @date 2021-01-08 13:25:45
*/
package com.steel.yfmall.cloud.assistant.po.oms;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class OrderSettlementExample {
    /**
     * order_settlement
     */
    protected String orderByClause;

    /**
     * order_settlement
     */
    protected boolean distinct;

    /**
     * order_settlement
     */
    protected List<Criteria> oredCriteria;

    private Integer limit;

    private Integer offset;

    private String groupByClause;

    private String selectFields;

    /**
     * 构造查询条件:order_settlement
     * @Title: OrderSettlementExample
     * @Description: ( )
     * @return 返回类型 null
     * @date 2021-01-08 13:25:45
     */
    public OrderSettlementExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * 设置排序字段:order_settlement
     * @Title: setOrderByClause
     * @Description: ( 设置排序字段 )
     * @param 参数说明 类型:String	名称:orderByClause 排序字段
     * @return 返回类型 null
     * @date 2021-01-08 13:25:45
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * 获取排序字段:order_settlement
     * @Title: getOrderByClause
     * @Description: ( 获取排序字段 )
     * @return 返回类型 java.lang.String
     * @date 2021-01-08 13:25:45
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * 设置过滤重复数据:order_settlement
     * @Title: setDistinct
     * @Description: ( 设置过滤重复数据 )
     * @param 参数说明 类型:boolean	名称:distinct 是否过滤重复数据
     * @return 返回类型 null
     * @date 2021-01-08 13:25:45
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     * 是否过滤重复数据:order_settlement
     * @Title: isDistinct
     * @Description: ( 是否过滤重复数据 )
     * @return 返回类型 boolean
     * @date 2021-01-08 13:25:45
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * 获取当前的查询条件实例:order_settlement
     * @Title: getOredCriteria
     * @Description: ( 获取当前的查询条件实例 )
     * @return 返回类型 java.util.List<Criteria>
     * @date 2021-01-08 13:25:45
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     *:order_settlement
     * @Title: or
     * @Description: ( )
     *
     * @param 参数说明 类型:Criteria	名称:criteria 过滤条件实例
     * @return 返回类型 null
     * @date 2021-01-08 13:25:45
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     *:order_settlement
     * @Title: or
     * @Description: ( )
     *
     * @return 返回类型 Criteria
     * @date 2021-01-08 13:25:45
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * 创建一个查询条件:order_settlement
     * @Title: createCriteria
     * @Description: ( 创建一个查询条件 )
     * @return 返回类型 Criteria
     * @date 2021-01-08 13:25:45
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * 内部构建查询条件对象:order_settlement
     * @Title: createCriteriaInternal
     * @Description: ( 内部构建查询条件对象 )
     * @return 返回类型 Criteria
     * @date 2021-01-08 13:25:45
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * 清除查询条件:order_settlement
     * @Title: clear
     * @Description: ( 清除查询条件 )
     * @return 返回类型 null
     * @date 2021-01-08 13:25:45
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void limit(Integer offset, Integer limit) {
        this.offset = offset;
        this.limit = limit;
    }

    public Integer getLimit() {
        return limit;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return offset;
    }

    public void setGroupByClause(String groupByClause) {
        this.groupByClause = groupByClause;
    }

    public String getGroupByClause() {
        return groupByClause;
    }

    public void setSelectFields(String selectFields) {
        this.selectFields = selectFields;
    }

    public String getSelectFields() {
        return selectFields;
    }

    /**
     * @title order_settlement表的实体类
     * @description order_settlement
     * @version 1.0
     * @author 18304
     * @date 2021-01-08 13:25:45
     */
    protected abstract static class GeneratedCriteria implements java.io.Serializable {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNull() {
            addCriterion("order_no is null");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNotNull() {
            addCriterion("order_no is not null");
            return (Criteria) this;
        }

        public Criteria andOrderNoEqualTo(String value) {
            addCriterion("order_no =", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotEqualTo(String value) {
            addCriterion("order_no <>", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThan(String value) {
            addCriterion("order_no >", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThanOrEqualTo(String value) {
            addCriterion("order_no >=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThan(String value) {
            addCriterion("order_no <", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThanOrEqualTo(String value) {
            addCriterion("order_no <=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLike(String value) {
            addCriterion("order_no like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotLike(String value) {
            addCriterion("order_no not like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoIn(List<String> values) {
            addCriterion("order_no in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotIn(List<String> values) {
            addCriterion("order_no not in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoBetween(String value1, String value2) {
            addCriterion("order_no between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotBetween(String value1, String value2) {
            addCriterion("order_no not between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andCustNoIsNull() {
            addCriterion("cust_no is null");
            return (Criteria) this;
        }

        public Criteria andCustNoIsNotNull() {
            addCriterion("cust_no is not null");
            return (Criteria) this;
        }

        public Criteria andCustNoEqualTo(String value) {
            addCriterion("cust_no =", value, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoNotEqualTo(String value) {
            addCriterion("cust_no <>", value, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoGreaterThan(String value) {
            addCriterion("cust_no >", value, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoGreaterThanOrEqualTo(String value) {
            addCriterion("cust_no >=", value, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoLessThan(String value) {
            addCriterion("cust_no <", value, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoLessThanOrEqualTo(String value) {
            addCriterion("cust_no <=", value, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoLike(String value) {
            addCriterion("cust_no like", value, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoNotLike(String value) {
            addCriterion("cust_no not like", value, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoIn(List<String> values) {
            addCriterion("cust_no in", values, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoNotIn(List<String> values) {
            addCriterion("cust_no not in", values, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoBetween(String value1, String value2) {
            addCriterion("cust_no between", value1, value2, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoNotBetween(String value1, String value2) {
            addCriterion("cust_no not between", value1, value2, "custNo");
            return (Criteria) this;
        }

        public Criteria andShipDateIsNull() {
            addCriterion("ship_date is null");
            return (Criteria) this;
        }

        public Criteria andShipDateIsNotNull() {
            addCriterion("ship_date is not null");
            return (Criteria) this;
        }

        public Criteria andShipDateEqualTo(Date value) {
            addCriterion("ship_date =", value, "shipDate");
            return (Criteria) this;
        }

        public Criteria andShipDateNotEqualTo(Date value) {
            addCriterion("ship_date <>", value, "shipDate");
            return (Criteria) this;
        }

        public Criteria andShipDateGreaterThan(Date value) {
            addCriterion("ship_date >", value, "shipDate");
            return (Criteria) this;
        }

        public Criteria andShipDateGreaterThanOrEqualTo(Date value) {
            addCriterion("ship_date >=", value, "shipDate");
            return (Criteria) this;
        }

        public Criteria andShipDateLessThan(Date value) {
            addCriterion("ship_date <", value, "shipDate");
            return (Criteria) this;
        }

        public Criteria andShipDateLessThanOrEqualTo(Date value) {
            addCriterion("ship_date <=", value, "shipDate");
            return (Criteria) this;
        }

        public Criteria andShipDateIn(List<Date> values) {
            addCriterion("ship_date in", values, "shipDate");
            return (Criteria) this;
        }

        public Criteria andShipDateNotIn(List<Date> values) {
            addCriterion("ship_date not in", values, "shipDate");
            return (Criteria) this;
        }

        public Criteria andShipDateBetween(Date value1, Date value2) {
            addCriterion("ship_date between", value1, value2, "shipDate");
            return (Criteria) this;
        }

        public Criteria andShipDateNotBetween(Date value1, Date value2) {
            addCriterion("ship_date not between", value1, value2, "shipDate");
            return (Criteria) this;
        }

        public Criteria andPriceDateIsNull() {
            addCriterion("price_date is null");
            return (Criteria) this;
        }

        public Criteria andPriceDateIsNotNull() {
            addCriterion("price_date is not null");
            return (Criteria) this;
        }

        public Criteria andPriceDateEqualTo(Date value) {
            addCriterion("price_date =", value, "priceDate");
            return (Criteria) this;
        }

        public Criteria andPriceDateNotEqualTo(Date value) {
            addCriterion("price_date <>", value, "priceDate");
            return (Criteria) this;
        }

        public Criteria andPriceDateGreaterThan(Date value) {
            addCriterion("price_date >", value, "priceDate");
            return (Criteria) this;
        }

        public Criteria andPriceDateGreaterThanOrEqualTo(Date value) {
            addCriterion("price_date >=", value, "priceDate");
            return (Criteria) this;
        }

        public Criteria andPriceDateLessThan(Date value) {
            addCriterion("price_date <", value, "priceDate");
            return (Criteria) this;
        }

        public Criteria andPriceDateLessThanOrEqualTo(Date value) {
            addCriterion("price_date <=", value, "priceDate");
            return (Criteria) this;
        }

        public Criteria andPriceDateIn(List<Date> values) {
            addCriterion("price_date in", values, "priceDate");
            return (Criteria) this;
        }

        public Criteria andPriceDateNotIn(List<Date> values) {
            addCriterion("price_date not in", values, "priceDate");
            return (Criteria) this;
        }

        public Criteria andPriceDateBetween(Date value1, Date value2) {
            addCriterion("price_date between", value1, value2, "priceDate");
            return (Criteria) this;
        }

        public Criteria andPriceDateNotBetween(Date value1, Date value2) {
            addCriterion("price_date not between", value1, value2, "priceDate");
            return (Criteria) this;
        }

        public Criteria andContractNoIsNull() {
            addCriterion("contract_no is null");
            return (Criteria) this;
        }

        public Criteria andContractNoIsNotNull() {
            addCriterion("contract_no is not null");
            return (Criteria) this;
        }

        public Criteria andContractNoEqualTo(String value) {
            addCriterion("contract_no =", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoNotEqualTo(String value) {
            addCriterion("contract_no <>", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoGreaterThan(String value) {
            addCriterion("contract_no >", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoGreaterThanOrEqualTo(String value) {
            addCriterion("contract_no >=", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoLessThan(String value) {
            addCriterion("contract_no <", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoLessThanOrEqualTo(String value) {
            addCriterion("contract_no <=", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoLike(String value) {
            addCriterion("contract_no like", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoNotLike(String value) {
            addCriterion("contract_no not like", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoIn(List<String> values) {
            addCriterion("contract_no in", values, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoNotIn(List<String> values) {
            addCriterion("contract_no not in", values, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoBetween(String value1, String value2) {
            addCriterion("contract_no between", value1, value2, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoNotBetween(String value1, String value2) {
            addCriterion("contract_no not between", value1, value2, "contractNo");
            return (Criteria) this;
        }

        public Criteria andOrderItemIsNull() {
            addCriterion("order_item is null");
            return (Criteria) this;
        }

        public Criteria andOrderItemIsNotNull() {
            addCriterion("order_item is not null");
            return (Criteria) this;
        }

        public Criteria andOrderItemEqualTo(String value) {
            addCriterion("order_item =", value, "orderItem");
            return (Criteria) this;
        }

        public Criteria andOrderItemNotEqualTo(String value) {
            addCriterion("order_item <>", value, "orderItem");
            return (Criteria) this;
        }

        public Criteria andOrderItemGreaterThan(String value) {
            addCriterion("order_item >", value, "orderItem");
            return (Criteria) this;
        }

        public Criteria andOrderItemGreaterThanOrEqualTo(String value) {
            addCriterion("order_item >=", value, "orderItem");
            return (Criteria) this;
        }

        public Criteria andOrderItemLessThan(String value) {
            addCriterion("order_item <", value, "orderItem");
            return (Criteria) this;
        }

        public Criteria andOrderItemLessThanOrEqualTo(String value) {
            addCriterion("order_item <=", value, "orderItem");
            return (Criteria) this;
        }

        public Criteria andOrderItemLike(String value) {
            addCriterion("order_item like", value, "orderItem");
            return (Criteria) this;
        }

        public Criteria andOrderItemNotLike(String value) {
            addCriterion("order_item not like", value, "orderItem");
            return (Criteria) this;
        }

        public Criteria andOrderItemIn(List<String> values) {
            addCriterion("order_item in", values, "orderItem");
            return (Criteria) this;
        }

        public Criteria andOrderItemNotIn(List<String> values) {
            addCriterion("order_item not in", values, "orderItem");
            return (Criteria) this;
        }

        public Criteria andOrderItemBetween(String value1, String value2) {
            addCriterion("order_item between", value1, value2, "orderItem");
            return (Criteria) this;
        }

        public Criteria andOrderItemNotBetween(String value1, String value2) {
            addCriterion("order_item not between", value1, value2, "orderItem");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoIsNull() {
            addCriterion("delivery_no is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoIsNotNull() {
            addCriterion("delivery_no is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoEqualTo(String value) {
            addCriterion("delivery_no =", value, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoNotEqualTo(String value) {
            addCriterion("delivery_no <>", value, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoGreaterThan(String value) {
            addCriterion("delivery_no >", value, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoGreaterThanOrEqualTo(String value) {
            addCriterion("delivery_no >=", value, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoLessThan(String value) {
            addCriterion("delivery_no <", value, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoLessThanOrEqualTo(String value) {
            addCriterion("delivery_no <=", value, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoLike(String value) {
            addCriterion("delivery_no like", value, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoNotLike(String value) {
            addCriterion("delivery_no not like", value, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoIn(List<String> values) {
            addCriterion("delivery_no in", values, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoNotIn(List<String> values) {
            addCriterion("delivery_no not in", values, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoBetween(String value1, String value2) {
            addCriterion("delivery_no between", value1, value2, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDeliveryNoNotBetween(String value1, String value2) {
            addCriterion("delivery_no not between", value1, value2, "deliveryNo");
            return (Criteria) this;
        }

        public Criteria andDisplistNoIsNull() {
            addCriterion("displist_no is null");
            return (Criteria) this;
        }

        public Criteria andDisplistNoIsNotNull() {
            addCriterion("displist_no is not null");
            return (Criteria) this;
        }

        public Criteria andDisplistNoEqualTo(String value) {
            addCriterion("displist_no =", value, "displistNo");
            return (Criteria) this;
        }

        public Criteria andDisplistNoNotEqualTo(String value) {
            addCriterion("displist_no <>", value, "displistNo");
            return (Criteria) this;
        }

        public Criteria andDisplistNoGreaterThan(String value) {
            addCriterion("displist_no >", value, "displistNo");
            return (Criteria) this;
        }

        public Criteria andDisplistNoGreaterThanOrEqualTo(String value) {
            addCriterion("displist_no >=", value, "displistNo");
            return (Criteria) this;
        }

        public Criteria andDisplistNoLessThan(String value) {
            addCriterion("displist_no <", value, "displistNo");
            return (Criteria) this;
        }

        public Criteria andDisplistNoLessThanOrEqualTo(String value) {
            addCriterion("displist_no <=", value, "displistNo");
            return (Criteria) this;
        }

        public Criteria andDisplistNoLike(String value) {
            addCriterion("displist_no like", value, "displistNo");
            return (Criteria) this;
        }

        public Criteria andDisplistNoNotLike(String value) {
            addCriterion("displist_no not like", value, "displistNo");
            return (Criteria) this;
        }

        public Criteria andDisplistNoIn(List<String> values) {
            addCriterion("displist_no in", values, "displistNo");
            return (Criteria) this;
        }

        public Criteria andDisplistNoNotIn(List<String> values) {
            addCriterion("displist_no not in", values, "displistNo");
            return (Criteria) this;
        }

        public Criteria andDisplistNoBetween(String value1, String value2) {
            addCriterion("displist_no between", value1, value2, "displistNo");
            return (Criteria) this;
        }

        public Criteria andDisplistNoNotBetween(String value1, String value2) {
            addCriterion("displist_no not between", value1, value2, "displistNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoIsNull() {
            addCriterion("trade_no is null");
            return (Criteria) this;
        }

        public Criteria andTradeNoIsNotNull() {
            addCriterion("trade_no is not null");
            return (Criteria) this;
        }

        public Criteria andTradeNoEqualTo(String value) {
            addCriterion("trade_no =", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoNotEqualTo(String value) {
            addCriterion("trade_no <>", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoGreaterThan(String value) {
            addCriterion("trade_no >", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoGreaterThanOrEqualTo(String value) {
            addCriterion("trade_no >=", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoLessThan(String value) {
            addCriterion("trade_no <", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoLessThanOrEqualTo(String value) {
            addCriterion("trade_no <=", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoLike(String value) {
            addCriterion("trade_no like", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoNotLike(String value) {
            addCriterion("trade_no not like", value, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoIn(List<String> values) {
            addCriterion("trade_no in", values, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoNotIn(List<String> values) {
            addCriterion("trade_no not in", values, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoBetween(String value1, String value2) {
            addCriterion("trade_no between", value1, value2, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andTradeNoNotBetween(String value1, String value2) {
            addCriterion("trade_no not between", value1, value2, "tradeNo");
            return (Criteria) this;
        }

        public Criteria andSpecMarkIsNull() {
            addCriterion("spec_mark is null");
            return (Criteria) this;
        }

        public Criteria andSpecMarkIsNotNull() {
            addCriterion("spec_mark is not null");
            return (Criteria) this;
        }

        public Criteria andSpecMarkEqualTo(String value) {
            addCriterion("spec_mark =", value, "specMark");
            return (Criteria) this;
        }

        public Criteria andSpecMarkNotEqualTo(String value) {
            addCriterion("spec_mark <>", value, "specMark");
            return (Criteria) this;
        }

        public Criteria andSpecMarkGreaterThan(String value) {
            addCriterion("spec_mark >", value, "specMark");
            return (Criteria) this;
        }

        public Criteria andSpecMarkGreaterThanOrEqualTo(String value) {
            addCriterion("spec_mark >=", value, "specMark");
            return (Criteria) this;
        }

        public Criteria andSpecMarkLessThan(String value) {
            addCriterion("spec_mark <", value, "specMark");
            return (Criteria) this;
        }

        public Criteria andSpecMarkLessThanOrEqualTo(String value) {
            addCriterion("spec_mark <=", value, "specMark");
            return (Criteria) this;
        }

        public Criteria andSpecMarkLike(String value) {
            addCriterion("spec_mark like", value, "specMark");
            return (Criteria) this;
        }

        public Criteria andSpecMarkNotLike(String value) {
            addCriterion("spec_mark not like", value, "specMark");
            return (Criteria) this;
        }

        public Criteria andSpecMarkIn(List<String> values) {
            addCriterion("spec_mark in", values, "specMark");
            return (Criteria) this;
        }

        public Criteria andSpecMarkNotIn(List<String> values) {
            addCriterion("spec_mark not in", values, "specMark");
            return (Criteria) this;
        }

        public Criteria andSpecMarkBetween(String value1, String value2) {
            addCriterion("spec_mark between", value1, value2, "specMark");
            return (Criteria) this;
        }

        public Criteria andSpecMarkNotBetween(String value1, String value2) {
            addCriterion("spec_mark not between", value1, value2, "specMark");
            return (Criteria) this;
        }

        public Criteria andBeginWareHouseNoIsNull() {
            addCriterion("begin_ware_house_no is null");
            return (Criteria) this;
        }

        public Criteria andBeginWareHouseNoIsNotNull() {
            addCriterion("begin_ware_house_no is not null");
            return (Criteria) this;
        }

        public Criteria andBeginWareHouseNoEqualTo(String value) {
            addCriterion("begin_ware_house_no =", value, "beginWareHouseNo");
            return (Criteria) this;
        }

        public Criteria andBeginWareHouseNoNotEqualTo(String value) {
            addCriterion("begin_ware_house_no <>", value, "beginWareHouseNo");
            return (Criteria) this;
        }

        public Criteria andBeginWareHouseNoGreaterThan(String value) {
            addCriterion("begin_ware_house_no >", value, "beginWareHouseNo");
            return (Criteria) this;
        }

        public Criteria andBeginWareHouseNoGreaterThanOrEqualTo(String value) {
            addCriterion("begin_ware_house_no >=", value, "beginWareHouseNo");
            return (Criteria) this;
        }

        public Criteria andBeginWareHouseNoLessThan(String value) {
            addCriterion("begin_ware_house_no <", value, "beginWareHouseNo");
            return (Criteria) this;
        }

        public Criteria andBeginWareHouseNoLessThanOrEqualTo(String value) {
            addCriterion("begin_ware_house_no <=", value, "beginWareHouseNo");
            return (Criteria) this;
        }

        public Criteria andBeginWareHouseNoLike(String value) {
            addCriterion("begin_ware_house_no like", value, "beginWareHouseNo");
            return (Criteria) this;
        }

        public Criteria andBeginWareHouseNoNotLike(String value) {
            addCriterion("begin_ware_house_no not like", value, "beginWareHouseNo");
            return (Criteria) this;
        }

        public Criteria andBeginWareHouseNoIn(List<String> values) {
            addCriterion("begin_ware_house_no in", values, "beginWareHouseNo");
            return (Criteria) this;
        }

        public Criteria andBeginWareHouseNoNotIn(List<String> values) {
            addCriterion("begin_ware_house_no not in", values, "beginWareHouseNo");
            return (Criteria) this;
        }

        public Criteria andBeginWareHouseNoBetween(String value1, String value2) {
            addCriterion("begin_ware_house_no between", value1, value2, "beginWareHouseNo");
            return (Criteria) this;
        }

        public Criteria andBeginWareHouseNoNotBetween(String value1, String value2) {
            addCriterion("begin_ware_house_no not between", value1, value2, "beginWareHouseNo");
            return (Criteria) this;
        }

        public Criteria andSettleModeIsNull() {
            addCriterion("settle_mode is null");
            return (Criteria) this;
        }

        public Criteria andSettleModeIsNotNull() {
            addCriterion("settle_mode is not null");
            return (Criteria) this;
        }

        public Criteria andSettleModeEqualTo(String value) {
            addCriterion("settle_mode =", value, "settleMode");
            return (Criteria) this;
        }

        public Criteria andSettleModeNotEqualTo(String value) {
            addCriterion("settle_mode <>", value, "settleMode");
            return (Criteria) this;
        }

        public Criteria andSettleModeGreaterThan(String value) {
            addCriterion("settle_mode >", value, "settleMode");
            return (Criteria) this;
        }

        public Criteria andSettleModeGreaterThanOrEqualTo(String value) {
            addCriterion("settle_mode >=", value, "settleMode");
            return (Criteria) this;
        }

        public Criteria andSettleModeLessThan(String value) {
            addCriterion("settle_mode <", value, "settleMode");
            return (Criteria) this;
        }

        public Criteria andSettleModeLessThanOrEqualTo(String value) {
            addCriterion("settle_mode <=", value, "settleMode");
            return (Criteria) this;
        }

        public Criteria andSettleModeLike(String value) {
            addCriterion("settle_mode like", value, "settleMode");
            return (Criteria) this;
        }

        public Criteria andSettleModeNotLike(String value) {
            addCriterion("settle_mode not like", value, "settleMode");
            return (Criteria) this;
        }

        public Criteria andSettleModeIn(List<String> values) {
            addCriterion("settle_mode in", values, "settleMode");
            return (Criteria) this;
        }

        public Criteria andSettleModeNotIn(List<String> values) {
            addCriterion("settle_mode not in", values, "settleMode");
            return (Criteria) this;
        }

        public Criteria andSettleModeBetween(String value1, String value2) {
            addCriterion("settle_mode between", value1, value2, "settleMode");
            return (Criteria) this;
        }

        public Criteria andSettleModeNotBetween(String value1, String value2) {
            addCriterion("settle_mode not between", value1, value2, "settleMode");
            return (Criteria) this;
        }

        public Criteria andDeliWetIsNull() {
            addCriterion("deli_wet is null");
            return (Criteria) this;
        }

        public Criteria andDeliWetIsNotNull() {
            addCriterion("deli_wet is not null");
            return (Criteria) this;
        }

        public Criteria andDeliWetEqualTo(BigDecimal value) {
            addCriterion("deli_wet =", value, "deliWet");
            return (Criteria) this;
        }

        public Criteria andDeliWetNotEqualTo(BigDecimal value) {
            addCriterion("deli_wet <>", value, "deliWet");
            return (Criteria) this;
        }

        public Criteria andDeliWetGreaterThan(BigDecimal value) {
            addCriterion("deli_wet >", value, "deliWet");
            return (Criteria) this;
        }

        public Criteria andDeliWetGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("deli_wet >=", value, "deliWet");
            return (Criteria) this;
        }

        public Criteria andDeliWetLessThan(BigDecimal value) {
            addCriterion("deli_wet <", value, "deliWet");
            return (Criteria) this;
        }

        public Criteria andDeliWetLessThanOrEqualTo(BigDecimal value) {
            addCriterion("deli_wet <=", value, "deliWet");
            return (Criteria) this;
        }

        public Criteria andDeliWetIn(List<BigDecimal> values) {
            addCriterion("deli_wet in", values, "deliWet");
            return (Criteria) this;
        }

        public Criteria andDeliWetNotIn(List<BigDecimal> values) {
            addCriterion("deli_wet not in", values, "deliWet");
            return (Criteria) this;
        }

        public Criteria andDeliWetBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("deli_wet between", value1, value2, "deliWet");
            return (Criteria) this;
        }

        public Criteria andDeliWetNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("deli_wet not between", value1, value2, "deliWet");
            return (Criteria) this;
        }

        public Criteria andOrderUnitPriceIsNull() {
            addCriterion("order_unit_price is null");
            return (Criteria) this;
        }

        public Criteria andOrderUnitPriceIsNotNull() {
            addCriterion("order_unit_price is not null");
            return (Criteria) this;
        }

        public Criteria andOrderUnitPriceEqualTo(BigDecimal value) {
            addCriterion("order_unit_price =", value, "orderUnitPrice");
            return (Criteria) this;
        }

        public Criteria andOrderUnitPriceNotEqualTo(BigDecimal value) {
            addCriterion("order_unit_price <>", value, "orderUnitPrice");
            return (Criteria) this;
        }

        public Criteria andOrderUnitPriceGreaterThan(BigDecimal value) {
            addCriterion("order_unit_price >", value, "orderUnitPrice");
            return (Criteria) this;
        }

        public Criteria andOrderUnitPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("order_unit_price >=", value, "orderUnitPrice");
            return (Criteria) this;
        }

        public Criteria andOrderUnitPriceLessThan(BigDecimal value) {
            addCriterion("order_unit_price <", value, "orderUnitPrice");
            return (Criteria) this;
        }

        public Criteria andOrderUnitPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("order_unit_price <=", value, "orderUnitPrice");
            return (Criteria) this;
        }

        public Criteria andOrderUnitPriceIn(List<BigDecimal> values) {
            addCriterion("order_unit_price in", values, "orderUnitPrice");
            return (Criteria) this;
        }

        public Criteria andOrderUnitPriceNotIn(List<BigDecimal> values) {
            addCriterion("order_unit_price not in", values, "orderUnitPrice");
            return (Criteria) this;
        }

        public Criteria andOrderUnitPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_unit_price between", value1, value2, "orderUnitPrice");
            return (Criteria) this;
        }

        public Criteria andOrderUnitPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_unit_price not between", value1, value2, "orderUnitPrice");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andCountPriceIsNull() {
            addCriterion("count_price is null");
            return (Criteria) this;
        }

        public Criteria andCountPriceIsNotNull() {
            addCriterion("count_price is not null");
            return (Criteria) this;
        }

        public Criteria andCountPriceEqualTo(BigDecimal value) {
            addCriterion("count_price =", value, "countPrice");
            return (Criteria) this;
        }

        public Criteria andCountPriceNotEqualTo(BigDecimal value) {
            addCriterion("count_price <>", value, "countPrice");
            return (Criteria) this;
        }

        public Criteria andCountPriceGreaterThan(BigDecimal value) {
            addCriterion("count_price >", value, "countPrice");
            return (Criteria) this;
        }

        public Criteria andCountPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("count_price >=", value, "countPrice");
            return (Criteria) this;
        }

        public Criteria andCountPriceLessThan(BigDecimal value) {
            addCriterion("count_price <", value, "countPrice");
            return (Criteria) this;
        }

        public Criteria andCountPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("count_price <=", value, "countPrice");
            return (Criteria) this;
        }

        public Criteria andCountPriceIn(List<BigDecimal> values) {
            addCriterion("count_price in", values, "countPrice");
            return (Criteria) this;
        }

        public Criteria andCountPriceNotIn(List<BigDecimal> values) {
            addCriterion("count_price not in", values, "countPrice");
            return (Criteria) this;
        }

        public Criteria andCountPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("count_price between", value1, value2, "countPrice");
            return (Criteria) this;
        }

        public Criteria andCountPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("count_price not between", value1, value2, "countPrice");
            return (Criteria) this;
        }
    }

    /**
     * order_settlement
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * @title order_settlement表的实体类
     * @description order_settlement
     * @version 1.0
     * @author 18304
     * @date 2021-01-08 13:25:45
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}
